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 # 29241

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 820

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

CTS,

Data Stage 963

CHANGE CAPTURE

CTS,

Data Stage 891

AGGREGATOR default datatype

CTS,

Data Stage 931

Have you used Unstructured data?

CTS,

Data Stage 832

Triggers,VIEW,Procedures

CTS,

Data Stage 800

How to RD using transformer?

CTS,

Data Stage 857

How to Remove Duplicate using SQL?

CTS,

Data Stage 845

Lookup constraints

CTS,

Data Stage 838

Difference between JOIN,LOOKUP,MERGE?

CTS,

2 Data Stage 2208

EXPLAIN SCD

CTS,

Data Stage 960

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 953

Terminate Activity

CTS,

Data Stage 837

Notification Activity

CTS,

Data Stage 895

How to reverse the string using unix?

CTS,

Data Stage 2805

 [1]   2    Next



Answers / { anbuselvan }

Question { TCS, 14291 }

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 { 2140 }

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 { 4771 }

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