anbuselvan


{ City } chennai
< Country > india
* Profession * software engineer
User No # 122299
Total Questions Posted # 25
Total Answers Posted # 3

Total Answers Posted for My Questions # 4
Total Views for My Questions # 31991

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { anbuselvan }
Questions Answers Category Views Company eMail

How many Key we can define in remove duplicate stage?

CTS,

Data Stage 920

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

CTS,

Data Stage 1066

CHANGE CAPTURE

CTS,

Data Stage 980

AGGREGATOR default datatype

CTS,

Data Stage 1030

Have you used Unstructured data?

CTS,

Data Stage 920

Triggers,VIEW,Procedures

CTS,

Data Stage 900

How to RD using transformer?

CTS,

Data Stage 960

How to Remove Duplicate using SQL?

CTS,

Data Stage 950

Lookup constraints

CTS,

Data Stage 940

Difference between JOIN,LOOKUP,MERGE?

CTS,

2 Data Stage 2407

EXPLAIN SCD

CTS,

Data Stage 1043

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

CTS,

Data Stage 1043

Terminate Activity

CTS,

Data Stage 932

Notification Activity

CTS,

Data Stage 998

How to reverse the string using unix?

CTS,

Data Stage 2927

 [1]   2    Next



Answers / { anbuselvan }

Question { TCS, 14872 }

Difference in the implementation of lookup and join
stages,in joining two tables?


Answer

one more point to add on MERGE and LOOKUP
Merge can not allow duplicate records whereas LOOKUP will allow or can control duplicates using OPTION"MULTIPLE ROWS ON THE LINK" which is in constraint TAB.

Is This Answer Correct ?    0 Yes 0 No

Question { 2318 }

Hi,
My source is oracle(eno,ename,sal,commision,...), my
requirement is like this,
if there is a null values in commission col i want to keep
it as null,and for the remaining first two characters of
the value in my target.

Plz help me


Answer

src--->TFM--->Tgt

in TFM for Commission column derivation,assign
If commission = NULL then NULL else LEFT(commision,1,2)

Hope this will work....correct me if i am wrong.

Is This Answer Correct ?    1 Yes 0 No


Question { 5052 }

what is the difference between the join and look up
explin me one exmple


Answer

1.Join needs key column metadata should be same|Lookup key column metadata its not mandatory to be same
2.Implement Four join in JOIN|But in Lookup only TWO JOIN(left outer,INNER)
3.JOIN does not have reject link | LOOKUP has one reject link
4.Data should be sorted and default is hash partioning |LOOKUP data need not to be in sort and default partioning is ENTIRE
5.Performance is HIGH in JOIN | Performance is less in JOIN
6.Duplicate will arise in JOIN|can handle Duplicate in LOOKUP

Is This Answer Correct ?    0 Yes 0 No