Answer Posted / ananda
Join: When volume of data is more than 10 million in both
source and reference link.
Sparse Lookup: When reference data is > 500 million and
source data is <10 million.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How do you schedule or monitoring the job?
What are the types of containers and how to create them?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
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...
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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Can we use target hash file as a lookup ?
How to implement complex jobs in data stage?
What is the difference between datastage and informatica?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Explain entity, attribute and relationship in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to sort two columns in single job in datastage.
How to perform incremental load in datastage?
How do you import and export the datastage jobs?