From where you extract the data, how you did it into
informatica? explain....



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

Post New Answer

More Informatica Interview Questions

Describe data concatenation?

0 Answers  


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

0 Answers  


What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,


Explain the types of lookup transformation?

0 Answers  


Mention a few design and development best practices for informatica?

0 Answers  


How many repositories can we create in Informatica??

9 Answers   IBM, Patni,


i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,


In a sequential batch can u run the session if previous session fails?

3 Answers  


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.

2 Answers  


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?

3 Answers   TCS,


What is a connected transformation?

0 Answers   Informatica,


Categories