can you use flat file for lookup table?why?
Answers were Sorted based on User's Feedback
Answer / gyana
yes we can....we can definitly use the flat file as
lookup .....but we can not use the xml files as look
up...if u want to use then u have to change the xml file to
another database or flatfile..dn u can able to use
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / gyana
yes we can....we can definitly use the flat file as
lookup .....but we can not use the xml files as look
up...if u want to use then u have to change the xml file to
another database or flatfile..dn u can able to use
Is This Answer Correct ? | 2 Yes | 0 No |
Could you explain what is enterprise data warehouse?
Enlist some properties of sessions.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how many session run unix environment what command using ?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
How to recover sessions in concurrent batches?
how lookup is acting as both active and passive ? how is it possitble?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
What is surrogate key?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
star and snowflake schema?
Explain scd type 3 through mapping.