Interested to Buy Any Domain ? << Click Here >> for more details...
How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)
- 1 Answers
- 6074 Views
- I also Faced
- E-Mail Answers
Answer Posted / sarvesh
by using the sql override option in the edit properties in
s.q transformation,
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the difference steps for data modeling?
What are the steps involved in etl process?
What are the three tiers in etl?
tell me few points when u become TL
what are the facilities provided by data warehouse to analytical users?
explain the methodology of Data Warehousing?(Polaries)
what is data modeling?
what is the difference steps for data modeling?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how many steps are there in etl process?
Define slowly changing dimensions (SCD)?
Explain about round-robi?
how do u set partition points in the mapping?
Explain different types of partitioning?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
