ename like ibm,tcs,hcl need display those records only how?
- 2 Answers
- 6615 Views
- I also Faced
- E-Mail Answers
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 |
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
why do we need a datawarehouse when we have databases to store data?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How did you reconcile source with target?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
With out using Funnel Stage, how to populate the data from different sources to single target
What are some prerequisites for datastage?
how can you generate sequence number using only the sequential file stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How to convert table data into xml file using xml output stage? please explain step by step;
Teradata 
