Interested to Buy Any Domain ? << Click Here >> for more details...
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
- 2 Answers
- 7297 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vijaya
above answer only for the first time data loading only for new
record inserts to source it gives false results
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Define pmcmd command?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the different clients of powercenter?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
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
Mention few advantages of router transformation over filter transformation.
What is the difference between router and filter?
What does refresh system mean, and what are its distinctive choice?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
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.
Is it possible to define a single node as a Gateway node as well as worker node?
Which version configuration tool used in ur project?
what are 3 tech challenges/ common issues you face?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
