Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 3 Answers
- 12074 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri47
It Actually depends on the nature of the Column on which
you are goint to create an index.
Bit Map: If the column is of type Flag means contains 1 or
0.
Binary: If the column cintains numerical values.
Partitions also can be created if column values contains
only some list of values .
| Is This Answer Correct ? | 2 Yes | 0 No |
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is procedure to use mapping variable in source qualifier transformation? with example
Can we run session without using workflows?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What is rank transform?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
what is data driven in informatica
Explain sessions. Explain how batches are used to combine executions?
Difference between session variables and workflow variables?
Teradata 
