Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18

How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.

Answer Posted / dinesh

Find MOD9 based on input data say we call as MOD

constraint in transformer

Target 1 - MOD IN 1,2,3
Target 2 - MOD IN 4,5,6
Target 3 - MOD in 7,8,0

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can covert server job to a parallel job?

1153


Highlight the main features of datastage?

1163


root tree will find which is server job and which is parallel job?

1972


Which commands are used to import and export the datastage jobs?

1414


Explain ibm infosphere information server and highlight its main features?

1093


Define Merge?

1324


Differentiate between Join, Merge and Lookup stage?

1095


How many areas for files does datastage have?

1156


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2974


What steps should be taken to improve Datastage jobs?

1075


Differentiate between datastage and datastage tx?

1059


Define oconv () and iconv () functions in datastage?

1417


What is the difference between datastage and informatica?

1123


What are the different kinds of views available in a datastage director?

1033


how to implement scd2 in datastage 7.5 with lookup stage

5610