Write the unconnected lookup syntax?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
difference between informatica 8.1.1 and 8.6
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
what is the architecture of any Data warehousing project?
When we are using Dynamic Cache,which options we will select in session level?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
what is the size of your data warehousing?
How to recover the standalone session?
Enlist some properties of sessions.
What is flashback table ? Advance thanks
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same