From where you extract the data, how you did it into
informatica? explain....
Answer / davankumar
Its imp ??? every company should ask these ???.If source is
relation tables source data is relational (ie means oracle
9i/10g)
But source is flat that can in unix server(client can give
path details ).in informatica we have to create the
sturuture of table and give that path address in the
session property tab.
Is This Answer Correct ? | 4 Yes | 0 No |
Describe data concatenation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are teh different tasks that can be created in workflow manager?
Explain the types of lookup transformation?
Mention a few design and development best practices for informatica?
How many repositories can we create in Informatica??
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
In a sequential batch can u run the session if previous session fails?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
TELL ME ABOUT WORK FLOW SCHEDULING?
What is a connected transformation?