Can we use parameters of parameter file in presession
command
Answer / hemant.raut33
Yes ,we can use parameters of parameter file into
presession command of a task.
Is This Answer Correct ? | 1 Yes | 6 No |
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
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?
How we will implement Pushdown Optimization and Types in Informatica with better examples
Explain joiner transformation in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
what is incremental data aggregation?
Can you generate reports in Informatcia?
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?
what is update strategy transformation ?