Interested to Buy Any Domain ? << Click Here >> for more details...
I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
- 6 Answers
- 14207 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / tina
Use a lookup stage after the file. Do a self-lookup on this
file on empname. When the empname matches, take the empname
and company1 from stream link and company2 from reference
link and map to the target.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to find value from a column in a dataset?
How to manage date conversion in Datastage?
create a job that splits the data in the Jobs.txt file into
four output files. You will direct the data to the
different output files using constraints. • Job name:
JobLevels
• Source file: Jobs.txt
• Target file 1: LowLevelJobs.txt
− min_lvl between 0 and 25 inclusive.
− Same column types and headings as Jobs.txt.
− Include column names in the first line of the output file.
− Job description column should be preceded by the
string “Job
Title:” and embedded within square brackets. For example, if
the job description is “Designer”, the derived value
is: “Job
Title: [Designer]”.
• Target file 2: MidLevelJobs.txt
− min_lvl between 26 and 100 inclusive.
− Same format and derivations as Target file 1.
• Target file 3: HighLevelJobs.txt
− min_lvl between 101 and 500 inclusive.
− Same format and derivations as Target file 1.
• Rejects file: JobRejects.txt
− min_lvl is out of range, i.e., below 0 or above 500.
− This file has only two columns: job_id and reject_desc.
− reject_desc is a variable-length text field, maximum
length
100. It should contain a string of the form: “Level out of
range:
Define APT_CONFIG in Datastage?
What is the difference between validated and compiled in the datastage?
How do you import and export the datastage jobs?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is oci?
How will you move hashed file from one location to another location?
What a datastage macro?
Define project in datastage?
what are the errors,warnings in datastage
Why we use surrogate key?
How complex jobs are implemented in datstage to improve performance?
Difference between data warehousing and olap?
