Interested to Buy Any Domain ? << Click Here >> for more details...
why we need informatica
- 2 Answers
- 13414 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house
correct me if i was wrong
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / deepthi
etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.
| Is This Answer Correct ? | 3 Yes | 2 No |
In operator is used in which transformation in informatica 8.6.0
Enlist some properties of sessions.
What is meant by target load plan?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
how remove 1st 3 records & last 3 records in informatics
What is the function of union transformation?
Explain the tuning lookup transformation - informatica
Which transformation is needed while using the Cobol sources as source definitions?
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
In dimension and fact table? which one holds big data?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
Explain the mapping variable usage example in informatica
Teradata 
