Interested to Buy Any Domain ? << Click Here >> for more details...
Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.
Thanks in advance..
- 5 Answers
- 11936 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi ,
After every Source qualifier transformation just keep an
Expression with flag.
Dont go Single Source qualifier trans.
Keep 1 source qualifier trans for one table.
Any corrections let me know ,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the designer tools for creating transformations?
What's the layout of parameter file (what does a parameter file contain?)?
What are the mapping parameters and mapping variables?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What do you mean by filter 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.
What is domain in terms of informatica?
What is blocking transformation?
Can anyone tell me the new features in Informatica 9 Version?
How to update or delete the rows in a target, which do not have key fields?
How can we remove the duplicates from flat file source?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Enlist some properties of sessions.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
