Interested to Buy Any Domain ? << Click Here >> for more details...
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
TCS,
6 11835if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
7 9090wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
2 5500if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
IBM,
8 29481if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
IBM,
1 6285i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
10 15336Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
IBM,
4 9238i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
TCS,
2 5719wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
TCS,
4 13911i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
TCS,
5 10452Post New Informatica Questions
What are the differences between source qualifier and joiner transformation?
How to use pmcmd utility command?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is InformaticaPowerCenter?
How can informatica be used for an organization?
How to partition the Session?
In how many ways we can create ports?
Differences between connected and unconnected lookup?
How you can differentiate between connected lookup and unconnected lookup?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What does command task mean?
What is informatica metadata and where is it stored?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is a filter transformation?
What is fact table? Explain the different kinds of facts.
