Interested to Buy Any Domain ? << Click Here >> for more details...
1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.
2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.
3)i want to update the records without using updatestrategy
transformation.
4)what is diffrance between ab-intio and datastage than
compared to informatica.
5)what is the latest version of informatica in our field.
- 5 Answers
- 36185 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / rakesh
We can generate using MAPPING VARIABLE with SETCOUNTVARIABLE() function
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the way to execute pl/sql script using informatica mapping?
What is joiner change?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are active transformations.
What are the different types of repositories created using informatica?
According to his methodology what all you need before you build a datawarehouse
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
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?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to update a particular record in target with out running whole workflow?
what is mean by complex business rule ?
What do you understand by term role-playing dimension?
What is the maplet?
