Interested to Buy Any Domain ? << Click Here >> for more details...
source which format u will get either fixed or delimiter
length format? what is the symbol of delimiter?
- 2 Answers
- 6445 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas
Hi,
If the source is file then the records is separated by
either fixed length or delimiter format. and the symbol of
delimiter means any some special character separate the records
EG:Delimiter
Eid,Ename,Sal
1,aaa,2000
2,bbb,3000
EG:FixedLength
Eid Ename Sal
1 aaa 1000
2 bbb 2000
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / david
source file can be
1.delimeter file
2.fixed width file
if delimeter files delimeters will be like this
eg: , | @ # * space null /
for fixed width files
eg: fixed length no delimeter bw the records
| Is This Answer Correct ? | 0 Yes | 0 No |
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
Can you explain how could anyone drop the index before loading the data in target in datastage?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
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..
What are the steps needed to create a simple basic datastage job?
What is exact difference between Parallel Jobs and server Jobs..
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
Could anyone give brief explanation bout datastage admin
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Teradata 
