Interested to Buy Any Domain ? << Click Here >> for more details...
what are variable ports and list two situations when they
can be used?
- 4 Answers
- 16044 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / pooja ahmed
variable ports can be created in many trans.... the value
of the values will be used only with in that trans...
porpuse: to store the values n to perfoorm cal
for ex: in exp we take variable port to cal the
caluation.like sal+comm
or decode( partcost< 100,y,s)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is fact? What are the types of facts?
what is granularity in Data ware House?
what is the main role of FI on business
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
what is session partitioning?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what are the reports developed in sap bw project and what is the requirement for developing it?
What is a staging area? What is the purpose of a staging area?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What are the different Lookup methods used in Informatica?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is the difference between project backlog and product backlog?
Can there be sub steps of etl steps?
What is etl process? How many steps etl contains?
