I have worked on Informatica 7.1.1. I want to know the
answer for the below question.
Target is not created initially.Then how to take the DDL
script from the source and run the Mapping by creating the
Target dynamically?Is it possible by SQL Transformation?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of transformation available in informatica.
Which will beter perform IIf or decode?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
What is target load order?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Difference Between ETL & ELT?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What does reusable transformation mean?
What is workflow? What are the components of workflow manager?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What is union transformation in informatica?