Answer Posted / 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 |
Post New Answer View All Answers
Parameter and variable differences
What are the components of Informatica? And what is the purpose of each?
can you please explain me pre session and post session options?
What is session task and command task?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the limitations of joiner transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can we create multiple integration service on single repository?
What is the sql query overwrite in source qualifier in informatica
r u done any partitions in ur project?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the informatica performance improvement tips
What is workflow? What are the components of the workflow manager?
What will be the approach?