if u can't find what you are looking for in lookup table,
how do you handle?
Answer Posted / raj.arjunan
This Depend on the situation,
To Check the value is there or not there two ways
1. Use notfound function (if possible)
2. Check the Key value from lkp as NULL
Than based on the requirement generate error/Put default
value
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
how do u set partition points in the mapping?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
Which transformation we use to convert 'NA' to 'Not Available'
What are various etl tools in the market?
Explain the use lookup tables and Aggregate tables?
Do we need an etl tool?
What are the various tools used in etl?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What do you understand by active and passive transformations?
List few etl bugs?
Can u access a repository created in previous version of Informatica?
what make u disappointmnets in u r career
Can anyone explain me a scenario from banking and finance...more precisely a mapping