Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is 
Empno
1                               
2
3
4
5
6
7
8
9
10                             

                               
                               

Answers were Sorted based on User's Feedback



Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno..

Answer / soumya

Use pivot Stage.

Is This Answer Correct ?    11 Yes 3 No

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno..

Answer / prasad

yo ca use while loop to get this output take two loop variables one is for condtion in condition you should write like variable<=len(inputlink.string) and in loop variable use inputlink(indexnum,1) then you will get output like what you wanted

Is This Answer Correct ?    0 Yes 0 No

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno..

Answer / david

by using right and left function with loop function we can achieve this one

Is This Answer Correct ?    1 Yes 3 No

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno..

Answer / vijau

in sequential file stage just execute unix command head -1 command

Is This Answer Correct ?    0 Yes 4 No

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno..

Answer / xyz

use remove duplicate stage with first as the option for duplicate to return

Is This Answer Correct ?    0 Yes 15 No

Post New Answer

More Data Stage Interview Questions

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,


Notification Activity

0 Answers   CTS,


How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,


WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,


What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,


what are the types of nodes

4 Answers   HCL, TCS,


what is A Datastage?

2 Answers  


what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,


Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,


What is process model?

0 Answers  


Categories