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
- 5 Answers
- 10910 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / david
by using right and left function with loop function we can achieve this one
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / vijau
in sequential file stage just execute unix command head -1 command
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / xyz
use remove duplicate stage with first as the option for duplicate to return
| Is This Answer Correct ? | 0 Yes | 15 No |
In Datastage, how you can fix the truncated data error?
How will you move hashed file from one location to another location?
What are the third party tools you used in your project?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what is the Difference Between Datastage Server Edition and Parallel Edition?
how can we create tables in datastage?
Define orabulk and bcp stages?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
What is the importance of the exception activity in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
With out using Funnel Stage, how to populate the data from different sources to single target
Teradata 
