mike_in_chicago

 Profile Answers by mike_in_chicago Questions by mike_in_chicago

• Oct 21st, 2008

I think you want a router transformation... This way you can test if input(s) meet a needed criterion and "route" the records that do to correct targets.In Expression transformation you can test case with nested IIF statements in an expression...

Answer Question  Select Best Answer

HP Interview Question - How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it possible? How?

shiva4mba

 Profile Answers by shiva4mba Questions by shiva4mba

• Oct 13th, 2010

Yes it is possible Use aggregator after the source qualifierand put all the ports as group byit will give distinct records only

Answer Question  Select Best Answer

ramesh raju

• Nov 20th, 2007

Reusable transformation is a single transformatin, which can be resuable & mapplet is a set of transformations which can be reusable.

Answer Question  Select Best Answer

(connected & un connected)

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Nov 17th, 2007

Look up transformation compares the soure with specified target table,and forwarded the records to next tranformation only matched records.If not match,it returns NULL

Answer Question  Select Best Answer

I want to fail the session if the SAL=5000. How can we do it?

swapnl0201

 Profile Answers by swapnl0201 Questions by swapnl0201

• Jun 16th, 2010

As I understand your 2nd question.You want to stop/fail session/mapping on some condition.You should use abort function to fail the workflow.

Answer Question  Select Best Answer

naina

• Oct 6th, 2007

The mapplets cant use these following transformationsxml source qualifiernormalizernon-reusable sequence generator (it can use only reusable sequence generator)

Answer Question  Select Best Answer

swaphoney

• Nov 26th, 2007

You can achive this by using the reusable tranformation wizard, or can be achived by marking the already created tranformation as reusable 

Answer Question  Select Best Answer

pasupula.naidu

 Profile Answers by pasupula.naidu Questions by pasupula.naidu

• Dec 31st, 2010

1. Tools->mappletdesigner->create->give a name2. From tr menu->create->mapplet input3.
In, mapplet input tr create required ports4. Create required group of tr like sorter,exp5.
Drag the ports from mapplet input to the tr6. Create mapplet output t/rand finally save the mapplet in the repository

Answer Question  Select Best Answer

ajaybhosal

 Profile Answers by ajaybhosal Questions by ajaybhosal

• Jun 4th, 2010

When the target is used by Update Strategy T/R DD_REJECT, DD_UPDATE with some limited count, and if the number of rejected records exceed that count, then the session ends with failed status. This error is known as threshold error.

Answer Question  Select Best Answer

In a unix environment I have an application that takes several arguments. One of these I get from a session mapping. How do I pass this argument into my application?

Mohan

• Aug 12th, 2018

You can pass the session variable to workflow variable though post session variable assignment and then use the worklow variable as an argument in the command task

Answer Question  Select Best Answer

DK_Reddy

 Profile Answers by DK_Reddy Questions by DK_Reddy

• Apr 19th, 2009

Informatica Repository Server Holds some data for Mapping transformations and after modifications(Calculations) that data will move to target (as per client requirement)This data will call as Metadata.?

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Nov 14th, 2007

Pre-session:Before executing session, this pre-session command executesPost-session:After the completion of execution of this session, the script in the post-session runs.

Answer Question  Select Best Answer

Nick

• Nov 20th, 2007

INF Basic Data flow means Extraction, Transformation and Loading of data from Source to the target.CheersNick

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

By using the typeII mapping i.e. we use a seperate flag key which keeps changing when we changet the date in the table

Answer Question  Select Best Answer

nandu214

 Profile Answers by nandu214 Questions by nandu214

• Jun 17th, 2008

HiFirst u run initial laod with startdate and enddate next take enddate as startdate for incremental loading it wil add the data for previous like this we can do incremental loadingHope this helps

Answer Question  Select Best Answer

naresh

• Nov 19th, 2007

It is not possible to change the target table dynamically. According to me, we can change the connection of the table dynamically by changing the session properties.

Answer Question  Select Best Answer

gdngajudn

 Profile Answers by gdngajudn Questions by gdngajudn

• Nov 29th, 2007

Execution of this query will give an error.We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype.

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

ODBC is the database drivers  which is used to connect from clinet  to the relational database.DSN is the data service name which is thename of the odbc name give by the customer inoreder to...

Answer Question  Select Best Answer

ajmani

 Profile Answers by ajmani Questions by ajmani

• Dec 5th, 2007

This can be done by a pre sql script in the session.simply go to session->mappings->target.there in presql script give truncate table tablename.

Answer Question  Select Best Answer

komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 26th, 2007

First we should generate theWarehouse key using sequence generator and insert the rows into the target using update strategy

Answer Question  Select Best Answer