How to load data into 3 target tables which are in
different schema but with the same name and same relational
connection at infromatica level ?
How to differentiate while loading ? and how to load ?
- 2 Answers
- 8808 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kritika
in the session we can give different connections based upon the database we want to load. In each table there will be different connection where we can give different database name
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is Session and Batches?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is lookup transformation?
What is the advantage of informatica?
What is a connected transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are session parameters ? How do you set them?
Explain scd type 3 through mapping.
Explain the difference between a data warehouse and a data mart?
What are the types of caches in lookup? Explain them.
When do you use sql override in a lookup transformation?
What does role playing dimension mean?
Plz can any one say me how to get the informatica certification materials and dumps
Explain the different dimensions.
