Under what conditions selecting sorted input in aggregator will still not boost session performance?
1027Post New Informatica Questions
What is the surrogate key?
What is meant by a domain?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
lookup transformation with screenshots
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the reusable transformation?
In informatics server which files are created during the session rums?
As union transformation gives UNION ALL output, how you will get the UNION output?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How union transformation is used?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??