I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
Answer Posted / sweta
Hi Mukesh,
Can u pls send me the informatica certification dumps ASAP.
Even i m planning to do the certification within a month.
Thanks
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a sorter transformation?
How many numbers of sessions can one group in batches?
How to load a Dimension ? and how to load a fact table?
What are batches?
What you know about transaction control transformation?
lookup transformation with screenshots
What is the scenario which compels informatica server to reject files?
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)
What is aggregate cache in aggregator transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What the difference is between a database, a data warehouse and a data mart?
What is data caches/ index caches?