Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Bitmap and Btree index?
- 3 Answers
- 19828 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / ranvir thakor
WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How do you update the records with or without using update strategy?
what is $$$$?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the data movement modes in informatica?
What is an Integration service in Informatica?
What is a passive transformation?
Repository user profiles
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How would you copy the content of one repository to another repository?
server hot-ws270 is connect to Repository B. What does it mean?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is data movement mode in Informatica and difference between them?
Define pmcmd command?
What is the use of code page?
