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

What are the types of containers in datastage?

0 Answers  


how to delete one row in target dataset

0 Answers   Satyam,


what is repositery?

0 Answers   IBM,


i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  


How to implement complex jobs in data stage?

0 Answers  


What is the difference between orabulk and bcp stages?

0 Answers  


Is the value of staging variable stored temporarily or permanently?

0 Answers  


What is RCP

5 Answers   CGI, CTS,


What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,


Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,


Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,


Categories