Interested to Buy Any Domain ? << Click Here >> for more details...
What is informatica?
What exactly are the practical uses in real world
- 2 Answers
- 6076 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Informatica is an ETL tool used in DWH concept.
It keeps historical data. So all those organizations who wants
to keep their all data i.e. updated and historical too(not
only to update data and deleting the old data) can use it.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / jagadeesh gaddam
Informatica is an etl toll .it loads the data from various oltps like homogenius as well as hetrogeniuse.based on this loadig data we can genarate the reports what we exactly want for our business development and anyalise the business and take the right decissions
| Is This Answer Correct ? | 0 Yes | 0 No |
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What are differences between Informatica 7.1 and 6.1
where actually the usage of push down optimization happens...
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
what is filelist concept in informatica
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
how will compare two mappings in two different repository?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
what is metadata?
how to join the two flatfiles using the joiner t/r if there is no matching port?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Teradata 
