Can we get 1st record through Informatica(without sequence number).
No Answer is Posted For this Question
Be the First to Post Answer
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
How to load last n records of file into target table - informatica
what is the command to get the list of files in a directory in unix?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Under what conditions selecting sorted input in aggregator will still not boost session performance?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
how will you get 21 to 30 record from 50 records?