If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
if 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 700007 6218
wat 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 352 4016
if 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!!!
if 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??
i 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 11235
How to eliminate duplicates from flat file..what is the procedure4 6078
Suppose 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
i 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
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
i 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
Is there any way to read the ms excel datas directly into informatica?
What are the restrictions of union transformation?
How can we remove the duplicates from flat file source?
How to do unit testing in informatica?
Explain informatica architecture - version 8 / 9
What is target designer and target load order?
tell me 5 session failure in real time how can you solve that in your project?
lookup transformation with screenshots
What is the sequence generator transformation in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
What is the need for an etl tool?
Is stop and abort are same in informatica?
What does role playing dimension mean?
How many types of sessions are there in informatica.please explain them?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures