Interested to Buy Any Domain ? << Click Here >> for more details...
Source contains the metadata
source
-----
hyderabad,chennai,bangalore by using nested loop sequence
select source as hyderabad in target just run target as
hyderabad only not others please give me answer thanks in
advance(give reply how to wrote logic using nested loop
sequence)
- 1 Answers
- 3583 Views
- IBM, I also Faced
- E-Mail Answers
Why we use surrogate key?
how many types of remove the duplicate records?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the sortmerge collector?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
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?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
How to use Environment variable's in datastage?(use of process)
What is difference between server jobs & parallel jobs?
what is diff b/w datastage 8.1,8.5,8.7?
Teradata 
