Why we use assignment task in Informatica and what happens after we used it?

Rathi

• May 7th, 2016

An Assignment Task is used to assign a value to a user-defined workflow variable.

Answer Question  Select Best Answer

How to get the below output for following table ? can you please clarify this
--------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------

--------------------------
100 | null | null | null
--------------------------

Swapna

• Apr 21st, 2016

SELECT MAX(COL1), MAX(COL2), MAX(COL3),MAX(COL4) FROM TABLE

Answer Question  Select Best Answer

How to generate a negative sequence by using sequence generator?

M Farhan

• Dec 29th, 2018

String_concat(-,next_insequence());

Answer Question  Select Best Answer

What is row number, rank and dense rank? What are its uses?

nithish

• Oct 26th, 2016

rownum wiil give the sequence numbers and rank will work to skip the rows but coming to dense rank does not skip the rows for ex we have data like this sno name salary rowno rank dense_rank ...

Answer Question  Select Best Answer

What is the difference between case and decode?

Atal

• Sep 30th, 2016

CASE can handle the multi return type like if you need the sal between 5000 to 10000 it will handle but in case of DECODE it is not handled. So conclusion is that CASE handles multi return type but D...

Answer Question  Select Best Answer

IF we have a records like below with 2 way mfs using a partition by key, what will be the output.
Key here is Index(Column name)

Index
1
2
3
4
5
5
4
3
2
1

Udit

• Mar 5th, 2017

It must come like:
No., Partition_Value
1,2
2,2
3,2
4,2
5,2

Answer Question  Select Best Answer

Explain about Informatica Power Exchange
What are the important points in Informatica Power Exchange

Shubham R Lashkar

• Sep 22nd, 2022

Informatica PowerExchange is a family of products that enables an IT organization to retrieve all sources of enterprise data without having to develop custom data-access programs. By accessing mission...

Answer Question  Select Best Answer

What are the validations you perform from landing area to staging area?

snehal

• Aug 1st, 2017

We check data types, duplication, file types

Answer Question  Select Best Answer

How you will find the missing record in the target without using Minus?

VIVEK DIXIT

• Sep 27th, 2017

Count the rows and pass the port in the target

Answer Question  Select Best Answer

i/p col1||val1||col1||val2||col3||val3
o/p col1 col2 col3
val1 val2 val3
how to achieve this in AB initio

Sneha

• Jun 2nd, 2023

REFORMAT(input column :F1) let int C_FLAG = 0 out :: reformat(in) begin let int count = next_in_sequence(); if count%2 != 0; C_FLAG = string_substring(in.F1,4,1); end; out.COL1 :: if((coun...

Answer Question  Select Best Answer

navaneethvr

 Profile Answers by navaneethvr Questions by navaneethvr

• Jun 9th, 2009

In the Designer, you can create mapping variables in a mapping or mapplet. After you create a mapping variable, it appears in the Expression Editor. You can then use it in any expression in the mappin...

Praveen

• Aug 14th, 2005

  After creating a variable, we can use it in any expression in a mapping or a mapplet. Als they can be used in source qualifier filter, user defined joins or extract overrides and in expres...

Answer Question  Select Best Answer

Abhijit Jagtap

• Jul 12th, 2007

You can Oracle PL/SQL stored procedure from Informatica using the STORED PROCEDURE Transformation. But it needs ODBC connection. You can pass the parameters to the stored procedure through a mapping. There are two ways :-1. Stand alone2. in the mapping flow.

rajesh

• Jul 14th, 2005

We can use External Procedure Transformation to use external procedures. Both COM and Informatica Procedures are supported using External procedure Transformation

Answer Question  Select Best Answer

dvs

• Nov 5th, 2005

draw the inference if slowly changing dimension and based on the Type 1/2 or3  tables defined.

Andy

• Aug 23rd, 2005

When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Ord...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Apr 14th, 2006

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

paddy

• Dec 6th, 2005

Sq is a connected transform. cant do it.

Answer Question  Select Best Answer

Monark

• Jul 28th, 2006

IDP is the portal for display of reports, stored process, information maps and a whole bunch of thing ideally required for a dashboard reporting.IMS, is the gui to help u convert ur technical data and map it to business data (change names, add filters, add new columns etc)

Ram

• Jul 18th, 2006

In SAS what is Information Delivery Portal and Information Map StudioRegards,Ram

Answer Question  Select Best Answer

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Feb 22nd, 2007

Update strategy, Supposed you have a router you are router has 3 groups, 1 group is for update, 1 group is for delete, 1 group is for insert to target table.  You can use the update strategy for ...

Rangini vignesh

• Aug 29th, 2006

Ans:We can use Update strategy transformation in two ways .1.Mapping level.2.session level.Importence of Update strategy transformation in both cases as follows.In real time if we want to update the e...

Answer Question  Select Best Answer

jyothi_rayala

 Profile Answers by jyothi_rayala Questions by jyothi_rayala

• Feb 28th, 2011

2 options to tell aggregator input data is already sorted 1. If the sources are relational ,make sure that number of sorted ports are given in Source qualifier. 2. Include the Sorter transformation be...

Anonymous

• Oct 13th, 2006

By enablign sorted input property in Aggregator Properties

Answer Question  Select Best Answer

In BO Data integrator, metadata repository is in
A. Relational DB
B. File System (XML)
C. Proprietary Format

sonivx

 Profile Answers by sonivx Questions by sonivx

• Jun 16th, 2011

Relational Database

sixersiddu

 Profile Answers by sixersiddu Questions by sixersiddu

• Apr 3rd, 2010

Answer is A. It will be present in a Relational database.

Answer Question  Select Best Answer

Roger_009

 Profile Answers by Roger_009 Questions by Roger_009

• May 12th, 2008

Parameter files are used for static variable exectuion of a task. this file can b modifies/updated for later change in the parameter. say for ex, xyz="RAJAT" is defined in the parameter file...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 10th, 2006

You can pass a parameter value to a task using a file, Mostly it will be used in dynamic value assignment Sithu

Answer Question  Select Best Answer

siraj.khan

• Aug 3rd, 2007

With the help of a source Qualifier and Lookup we can overide SQL Query.

nashim

 Profile Answers by nashim Questions by nashim

• Jan 17th, 2007

We can override a sql query in the sql override property of a look up and update trasformations.

Answer Question  Select Best Answer