Source File: Target
EMPNO, SAL Empno, Format
101, 1000 101, 1000
101, 1100 101, 1000, 1100
101, 1000 101, 1000, 1100, 1000
101, 10000 101, 1000, 1100, 1000, 10000
102, 1100 102, 1100
102, 1300 102, 1100, 1300
102, 1200 102, 1100, 1300, 1200
102, 1500 102, 1100, 1300, 1200, 1500
How can i get that output using datastage(ETL) tool
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of firebase?
Is storing images in a database a good idea?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
what is rcp,if rcp disabled what happen?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What the various ways to tune a teradata query
What is a reference table in database?
Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key
What is the candidate key used for?
Write a query to retrieve for many to many relationships?
What is the difference between primary key, foreign key and candidate key?
What is Object Oriented model?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)