Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of Sequence Generator T/R?
- 3 Answers
- 16646 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / akhil4
using sequence generator t/r, u can not create sequence with alphabets
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
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.
What are the types of schemas we have in data warehouse.
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 is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What does reusable transformation mean?
What is blocking transformation?
Explain target update override in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the use of source qualifier?
Explain the mapping variable usage example in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to create the source and target database connections in server manager?
How to do the error handling of if ur source is flatfiles?
