Interested to Buy Any Domain ? << Click Here >> for more details...
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
L&T,
7 13810i 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 12349if 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 17017when 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 12544in 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 34434source : 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 11046By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
8 18943hi,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 9977Post New Informatica Questions
How to differentiate between the active and passive transformations?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the use of code page?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
lookup transformation with screenshots
What do you understand by a term domain?
Is there any target staging area in informatica not staging area
What does “tail –f” command do and what is its use as an Informatica admin.
What is the surrogate key?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is rank index in rank transformation?
Explain the aggregator transformation?
Explain informatica architecture - version 8 / 9
