Interested to Buy Any Domain ? << Click Here >> for more details...
if i have two tables
table1 table2
1a 1a,b,c,d
1b 2a,b,c,d,e
1c
1d
2a
2b
2c
2d
2e
how can i get data as same as in tables?chandu
how can i implement scd typ1 and type2 in both server and in parallel?chandu
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the ,inthe fields?
- 2 Answers
- 6945 Views
- I also Faced
- E-Mail Answers
Answer Posted / pakkya
implement scd type1 -
simply overwrite with new data
implement scd type2 -
use merge stage to do an inner join on all columns after
sorting data, rows that do not join from merge result are
your changes
remove ',' - use Trim function with A option that removes
all occurences of ','
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
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...
why do u need the IOS upgradation in a FC switch
Define APT_CONFIG in Datastage?
Why fact table is in normal form?
Highlight the main features of datastage?
What is ibm datastage flow designer?
What is active and passive stage?
options available in sequence job to run,validate?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is datastage?
Name the different sorting methods in datastage.
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the types of containers and how to create them?
