i have the source from Uk,north america how can i pass the
data two tables based on the locations
Answers were Sorted based on User's Feedback
question incomplete.
but still we can differentiate recs of uk & america.
we can use col gen and assign a small code(uk/us) to rec(s) of each table and funnel them if they have same metadata and do the processing thing and load the processed rec(s) to target depending upon the business requirements.
However guys plz provide basic details in questions so that proper answer can be given.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pooja
Basically the question is incomplete and not clear.
Based upon my understanding, we can consider country codes
for the records if location is the main criteria which are
unique for every country and can be processed further.
What exactly needs to be done with the records is not
stated in the question.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is advantages of snowflake when it is used?
Give an idea of system variables.
What is job control?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
What is a ds designer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok
how to add a new records into source?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
I am getting input value like X = Iconv(ā31 DEC 1967ā,āDā)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().