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 11827if 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 9077wat 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 5495if 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 29460if 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 6279i 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 15315Suppose 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 9227i 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 5711wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
TCS,
4 13903i 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 10445Post New Informatica Questions
what is the hint? how to use it to reduce the query processing in program?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you migrate data from one environment to another?
Differences between connected and unconnected lookup?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Where do we use mapping variables in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain dynamic target flat file name generation in informatica
To import the flat file definition into the designer where should the flat file be placed?
What is the difference between Active and Passive transformation?
What is the meaning of up gradation of repository?
What is informatica powercenter repository?
