Differentiate between a database and data warehouse?
No Answer is Posted For this Question
Be the First to Post Answer
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
What is sq transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
how to load rows into fact table in data warehouse
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
How to load last 10 records of flat file in to the target?
we have to use order by,where,having we to implement sql query
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
Parameter and variable differences
What happens to map if we alter the datatypes between source and its corresponding source qualifier?