COL1,COL2
ABC,1
XYZ,2
HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT
FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20)
O/P IS
COL1,COL2
ABC,2
XYZ,1
No Answer is Posted For this Question
Be the First to Post Answer
can u any challenge your project?
In development project what is the process to follow for an etl developer from day1
Can informatica load heterogeneous targets from heterogeneous sources?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Explain in detail about scd type 1 through mapping.
What is the Router transformation?
what is mean by throghput? in informatica
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic