When can we use stored procedure transformations.

rohit.khatod

 Profile Answers by rohit.khatod Questions by rohit.khatod

• Sep 14th, 2008

Whenever you need value from SP, that time you have to use store pro. transformation. Or whenever you would like to preform some activity on the DB after loading the data or before loading data through ETL process. It can be done through Shell scripts as well.

Answer Question  Select Best Answer

can anybody tell me that what are the processes used by cognos and Informatica for ETL Extraction, Scrubbing and Fusion. If you have any detailed report then please send me onmy mail ID...nm_105@yahoo.co.inthanks in Advance...

raambharathi

 Profile Answers by raambharathi Questions by raambharathi

• Sep 16th, 2009

Cognos and Informatica are not same tool that does the same work.Informatica is a ETL tool.  It extracts data from various sources (Oracle, db2, Sybase, etc) transforms it and loads data into ...

Answer Question  Select Best Answer

What is the use of the User defined Environment variables?

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 20th, 2009

User Defined Environment Variables are used to pass the parameters in job level,stage level and sequncer job level.Regards,Veeru.

Answer Question  Select Best Answer

What is the use of unconnected lookup transformation and exaplain with example?

pranambiar

 Profile Answers by pranambiar Questions by pranambiar

• Oct 26th, 2010

Informatica unconnected lookup can be taken as Oracle function. There are many scenario's in which unconnected lookup is preferred over connected one 1. When same lookup is to be used multiple tim...

Answer Question  Select Best Answer

jatin

• Feb 7th, 2013

Data-Centric Testing: Data-centric testing revolves around testing quality of the data. The objective of the data-centric testing is to ensure valid and correct data is in the system. Following are th...

Answer Question  Select Best Answer

suresh

• Jul 29th, 2015

Active and Passive Transformations:
Aggregator/Expression/Filter/Joiner/Rank/Router/Sequence Generator/Sorter/Source Qualifier/Union/Update Strategy Transformations

Answer Question  Select Best Answer

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

Sriharsha Hanumanth

• Aug 23rd, 2005

1. PowerMart Designer 2. Server 3. Server Manager 4. Repository 5. Repository Manager

Answer Question  Select Best Answer

sampath

• Jul 24th, 2005

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder wher...

Answer Question  Select Best Answer

anjanroy

 Profile Answers by anjanroy Questions by anjanroy

• Apr 14th, 2006

There are pros and cons of both tool based ETL and hand-coded ETL. Tool based ETL provides maintainability, ease of development and graphical view of the flow. It also reduces the learning curve on th...

Answer Question  Select Best Answer

sree,prabhakar

• Jul 14th, 2006

Additve: A masure can participate arithmatic calulatons using all or any demensions.Ex: Sales profitSemi additive: A masure can participate arithmatic calulatons using some demensions.Ex: Sales a...

Answer Question  Select Best Answer