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
- 10596 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / amarnath
if u r using informatica 8.0 n above u have a option to
load the name of the file. this is in the sq itself just
check the currently processed file name box. remember this
will give u the complete path of the file, hence u need to
substring it before loading it to tgt
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
What do you mean by worklet?
How to handle decimal places while importing a flatfile into informatica?
What is the maplet?
How to do unit testing in informatica? How to load data in informatica ?
How to create the source and target database connections in server manager?
What is a joiner transformation?
Explain constraint based loading in informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to use pmcmd utility command?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Mention few advantages of router transformation over filter transformation.
what is the complex transformation you used in informatica
Name the different lookup cache(s)?
