Interested to Buy Any Domain ? << Click Here >> for more details...
3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
- 7 Answers
- 10372 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vasu
Always Partition is the best option for huge volume
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is complex mapping?
How to configure mapping in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the size of u r source(like file or table)?
What are ETL Tools?
What is incremental aggregation?
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?
What are the differences between oltp and olap?
Sequence generator, when you move from develoment to production how will you reset
difference between repository database and repository service?
generate date / time dimension in informatica
What is the use of target designer?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
