4 yrs etl devloper roles and responsibilities?any body give
solutions
No Answer is Posted For this Question
Be the First to Post Answer
Please let me know how to make encryption and decryption with example?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain one complecated mapping?
how to load only the first and last record of a flat file into the target?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
in realtime which situations u can use unconnected lookup transformation
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.