ename like ibm,tcs,hcl need display those records only how?
Answers were Sorted based on User's Feedback
Answer / prasad
If the source is Oracle,or any Rdbms then use the 'where
clause' option in the 'available properties to add' tab
other wise we can done using 'filter or transformer'
Is This Answer Correct ? | 1 Yes | 1 No |
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
Why do we use link partitioner and link collector in datastage?
Demonstrate experience in maintaining quality process standards?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
What is the flow of loading data into fact & dimensional tables?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Is the value of staging variable stored temporarily or permanently?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the partition techniques available in your last project?
To see hidden files in LINIX?