can we override a native sql query within informatica? How do we do it?
No Answer is Posted For this Question
Be the First to Post Answer
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 an expression transformation differs from aggregator transformation?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Explain lookup transformation in informatica
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
what is unit testing?tell me proceedure
What does role playing dimension mean?
What do you mean by blocking transformation?
What are the uses of etl tools?