1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

Source contains the metadata
source
-----
hyderabad,chennai,bangalore by using nested loop sequence
select source as hyderabad in target just run target as
hyderabad only not others please give me answer thanks in
advance(give reply how to wrote logic using nested loop
sequence)

Question Posted / mehtha


Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested..

Answer / shiva

Please put your requirement clearly

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,




how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

EXPLAIN SCD

0 Answers   CTS,

What are the types of containers and how to create them?

0 Answers  

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

For more Data Stage Interview Questions Click Here
Categories