i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
L&T,
7 13841i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
L&T,
5 12375if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 17052when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
L&T,
5 12562in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
L&T,
11 34482source : 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
6 11058By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
8 18955hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
5 9987Post New Informatica Questions
What is meant by lookup transformation?
how to load dimension table and fact table. plz tell me the steps.
Can we get 1st record through Informatica(without sequence number).
What will be the approach?
wat are deployement groups in informatica, how it will be used for developers
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the differences between joiner transformation and source qualifier transformation?
can you please explain me pre session and post session options?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Enlist the tasks for which source qualifier transformation is used.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is olap (on-line analytical processing?
How many number of sessions can one group in batches?
How to convert multiple rows to single row (multiple columns) in informatica
Briefly explain the aggregator transformation?