what is set mapping in datastage??
Answers were Sorted based on User's Feedback
DataStage has built-in National Language Support (NLS).
Using NLS, the DataStage server engine holds data in Unicode
format. This is an international standard character set that
contains nearly all the characters used in languages around
the world. DataStage maps data to or from Unicode format as
required.
The maps define the character sets that the project can use.
The locales define the local formats for dates, times,
sorting order, and so on that the project can use
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / dinesh rathod
The easiest way of doing that from the Datastage standpoint is to configure no problems with string mappings
| Is This Answer Correct ? | 0 Yes | 1 No |
what is operator combinality in datastage?
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..
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
How to implement complex jobs in data stage?
what is flow of project?
What are the steps needed to create a simple basic datastage job?
Why we use parameters instead of hard code in datastage.
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
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
1)Source file contains one record, I want 100 records in target file.
ename like ibm,tcs,hcl need display those records only how?