explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
2158How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
CTS,
4 10531i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
TCS,
2 7855i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 18549Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
7 15299What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
1 9791Post New Informatica Questions
Mention a few design and development best practices for informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a transaction control transformation?
How can informatica be used for an organization?
How we can create indexes after completing the loan process?
What is intricate mapping?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What does reusable transformation mean?
how to load dimension table and fact table. plz tell me the steps.
What are different types of transformations available in informatica?
What is a snowflake schema?
What is the sql query overwrite in source qualifier in informatica
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
What is a dimensional model?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?