functional map runs only once
functional map runs only once
I have a functional map which should be creating one output record for each occurance of input record.According to the map designer interface guide ,we just need to pass the input type that occures multiple times as argument to functional map and rest will be taken care by Tx.
Structure of my input file is
Line1 -- Occurres once
Line2 -- Occurres multiple times
something like Order + Line Item scenario.
I created types as
Order(1)
LineItemDetails(S)
I created a functional map which takes LineItemDetails as arguement.As per the documentation functional map should be called for each occurrence of Line Item ,but i dont see that happening.I see only once the functional map is called and one row is created in Database.
Am i missing something ?
Structure of my input file is
Line1 -- Occurres once
Line2 -- Occurres multiple times
something like Order + Line Item scenario.
I created types as
Order(1)
LineItemDetails(S)
I created a functional map which takes LineItemDetails as arguement.As per the documentation functional map should be called for each occurrence of Line Item ,but i dont see that happening.I see only once the functional map is called and one row is created in Database.
Am i missing something ?
Iam not sure about whether my OutputCard is series or not ?
when you a series object do you mean multiple occurrances ?
Since my target is Database my output card is referring to a type called
LineItemDetails --->which has Row LINEITEM (S) where LINEITEM is my table name.
LineItemDetails ---> Row LINEITEM (s)
---> LINEITEM_ID
---> ITEM_NAME
---> ITEM_DESCRIPTION
when you a series object do you mean multiple occurrances ?
Since my target is Database my output card is referring to a type called
LineItemDetails --->which has Row LINEITEM (S) where LINEITEM is my table name.
LineItemDetails ---> Row LINEITEM (s)
---> LINEITEM_ID
---> ITEM_NAME
---> ITEM_DESCRIPTION
Yes, by "series object" I do mean an item that can occur more than once.
So I am guessing you have something like this:
Going into:
For this you would need to call your functional map from the LINEITEMS field in a manner something like this:
To iterate your series objects to correctly call a functional map, you need to use your input series object on an output card's series object.
I hope this helps,
John
So I am guessing you have something like this:
Code: Select all
InputCard
InputItems (s)
Code: Select all
LineItemDetails
LINEITEMS (s)
---> LINEITEM_ID
---> ITEM_NAME
---> ITEM_DESCRIPTION
Code: Select all
=F_Build_LineItem(InputItems)
I hope this helps,
John
I generated a type DBTable --> which has Row(s)jgibby wrote: To iterate your series objects to correctly call a functional map, you need to use your input series object on an output card's series object.
I hope this helps,
John
e.g.,
LINTEITEM-->DBTable --->Row(s) --->Column names
My Output card is mapped to DBTable,will this be considered a series object ?
Otherwise i have to figure out a way to make DBTable a series object.
You will want to call your functional map in the Row(s) element. That is your series object.jackcool wrote:I generated a type DBTable --> which has Row(s)jgibby wrote: To iterate your series objects to correctly call a functional map, you need to use your input series object on an output card's series object.
I hope this helps,
John
e.g.,
LINTEITEM-->DBTable --->Row(s) --->Column names
My Output card is mapped to DBTable,will this be considered a series object ?
Otherwise i have to figure out a way to make DBTable a series object.