Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
No Answer is Posted For this Question
Be the First to Post Answer
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
What are the different transaction levels available in transaction control transformation?
how do u move the code from development to production?
Can you use flat files in Mapplets.
Repository user profiles
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
Explain lookup transformation is active in informatica
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
How can i send first half of the records to one target and Remaining to other target?