How will u find weather dimension table is big in size of a
fact table?
Answer / tadikonda
if u have toad, u can find the tool option tab under that
ESTIMATE TABLE SIZE option,in that u can define the table
name and schema name ,in that way u can find which table is
big in size
| Is This Answer Correct ? | 1 Yes | 0 No |
how may sources can be used in a mapping at a time?(limit)
can we have to do changes in session property when we are dynamically generating target files?
How the dimensions will be loaded?
Differentiate between mapping parameter and mapping variable?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
How many ways are there to create ports?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
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
what is mean by grouping of condition column in lookup transformation?
How to run a session, which contains mapplet?
How will you update the first four rows and insert next four rows in a mapping?